package com.cs.beneficios.web.action;

import com.cs.beneficios.business.entity.BeneficioDAO;
import com.cs.beneficios.common.ConnectionFactory;

import java.io.IOException;

import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

public class EliminarBOTAction extends Action {
    /**This is the main action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     */
    public ActionForward execute(ActionMapping mapping, ActionForm form, 
                                 HttpServletRequest request, 
                                 HttpServletResponse response) throws IOException, 
                                                                      ServletException {
                                                                      
        //ConnectionFactory cf = new ConnectionFactory("beneficios","beneficios");
		ConnectionFactory cf = new ConnectionFactory();
        
        String codeBOT = request.getParameter("codeBot");

        BeneficioDAO beneficioDAO = new BeneficioDAO(cf);
                
        boolean isEliminado;

        try {
            isEliminado = beneficioDAO.deleteBOT(codeBOT);
            if(isEliminado){
                request.setAttribute("msg", "El beneficio otorgado fue eliminado exitosamente");
            } else {
                request.setAttribute("msg", "Error al eliminar el beneficio otorgado");
            }
        } catch (SQLException e) {
			System.err.println("/******** TDSUB - cwsub");
			e.printStackTrace();
			System.err.println("TDSSPE - cwsub ********/");
        }
        return mapping.findForward( "success");
    }
}
